k="name" v="Avenue des Plages"

SELECT * FROM way_tags WHERE k="name" and v = "Avenue des Plages"

tag id	key	value	Lien OSM
5082820	name	Avenue des Plages	OSM